﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="UserList.aspx.cs" Inherits="Crm_UserList" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
      <link href="crm.css" rel="stylesheet" type="text/css" />  <script src="../js/jquery-1.2.6.js" type="text/javascript"></script>

    <script type="text/javascript">
        $(document).ready(function()
        {
            var selobj = null;
            var selobjcolor = null;
            //d = this.style.backgroundColor; this.style.backgroundColor = '#D1F880';
            $(".trnei,.lupai").each(function()
            {

                $(this).click(function()
                {
                    try
                    {
                        selobj.css("background-color", selobjcolor);
                    }
                    catch (ex)
                    {
                    }
                    selobjcolor = $(this).css("background-color");
                    $(this).css("background-color", "#D1F880");
                    selobj = $(this);
                });
            });

        });
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <div style="padding: 0 5px;">
        <div class="nav">
            当前位置：加盟用户列表</div>
        <div style="margin-bottom: 5px;">
            </div>
        <asp:GridView ID="gvList" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" DataKeyNames="ID" AllowPaging="True">
            <Columns>
                <asp:BoundField DataField="ID" HeaderText="ID" ReadOnly="True" ItemStyle-Width="50px" SortExpression="ID" InsertVisible="False" />
                <asp:BoundField DataField="realname" HeaderText="真实名称"  SortExpression="realname" />
                <asp:BoundField DataField="sex" HeaderText="性别"  SortExpression="sex" />
                <asp:BoundField DataField="howold" HeaderText="年龄" SortExpression="howold" />
                <asp:BoundField DataField="address" HeaderText="地址" SortExpression="address" />
                <asp:BoundField DataField="company_name" HeaderText="公司名称" SortExpression="company_name" />
                <asp:BoundField DataField="company_address" HeaderText="公司地址" SortExpression="company_address" />
                <asp:BoundField DataField="jobtype" HeaderText="职业" SortExpression="jobtype" />
                <asp:BoundField DataField="phone" HeaderText="电话" SortExpression="phone" />
                <asp:BoundField DataField="fax" HeaderText="传真" SortExpression="fax" />
                <asp:BoundField DataField="touzitype" HeaderText="投资方式" SortExpression="touzitype" />
                <asp:BoundField DataField="gudongnum" HeaderText="股东数量" SortExpression="gudongnum" />
                <asp:BoundField DataField="isself" HeaderText="是否自己管理" SortExpression="isself" />
                <asp:BoundField DataField="manager" HeaderText="管理人" SortExpression="manager" />
                <asp:BoundField DataField="cash" HeaderText="计划投资(万元)" SortExpression="cash" />
                <asp:BoundField DataField="myselfcash" HeaderText="自有资金" SortExpression="myselfcash" />
                <asp:BoundField DataField="othercash" HeaderText="其他资金" SortExpression="othercash" />
                <asp:BoundField DataField="province" HeaderText="省份" SortExpression="province" />
                <asp:BoundField DataField="city" HeaderText="市" SortExpression="city" />
                <asp:BoundField DataField="county" HeaderText="县" SortExpression="county" />
                <asp:BoundField DataField="inputdate" HeaderText="填写日期" SortExpression="inputdate" />
            </Columns>
        </asp:GridView>
    </div>
    <%--<asp:SqlDataSource ID="" runat="server" ConnectionString="<%$ ConnectionStrings:strWeb %>" SelectCommand="SELECT a.*,b.sort_name FROM [News] a,NewsSorts b WHERE (a.sortId=b.sortId) ORDER BY [px] DESC" DeleteCommand="DELETE FROM [News] WHERE (newsId=@NewsId)">
        <SelectParameters>
            <asp:Parameter DefaultValue="0" Name="jb" Type="Int32" />
            <asp:Parameter DefaultValue="0" Name="pid" Type="Int32" />
        </SelectParameters>
        <DeleteParameters>
            <asp:Parameter Name="NewsId" Type="Int32" />
        </DeleteParameters>
    </asp:SqlDataSource>--%>
    <asp:AccessDataSource ID="SqlDataSource1" runat="server" DataFile="~/App_Data/flashcrm.mdb" SelectCommand="SELECT * FROM [Users]" DeleteCommand="DELETE FROM [Users] WHERE [ID] = ?">
        <DeleteParameters>
            <asp:Parameter Name="ID" Type="Int32" />
        </DeleteParameters>
      
    
    </asp:AccessDataSource>
    </form>
</body>
</html>
